package com.example.doctorserver.mapper;

import com.example.doctorserver.pojo.Overallresult;
import org.apache.ibatis.annotations.Delete;
import org.apache.ibatis.annotations.Insert;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

import java.util.List;

@Mapper
public interface OverallresultMapper {

    @Delete("delete from overallresult where orId=#{orId}")
    int removeById(Integer orId);

    int insert(Overallresult record);

    int insertSelective(Overallresult record);

    Overallresult selectByPrimaryKey(Integer orId);

    int updateById(Overallresult record);

    int updateByPrimaryKey(Overallresult record);

    @Insert("insert into overallresult values(null,#{title},#{content},#{orderId})")
    int saveOverallresult(Overallresult overallResult);

    @Select("select * from overallResult where orderId=#{orderId} order by orId")
    public List<Overallresult> listOverallResultByOrderId(Integer orderId);
}